<%@ page language="java" contentType="text/html; charset=GBK"%>
<% 
  response.setHeader("Pragma","No-cache"); 
  response.setHeader("Cache-Control","no-cache"); 
  response.setDateHeader("Expires", 0); 
%>
<%@ page import="java.util.*"%>
<%@ page import="com.ionglobal.db.*" %>
<%@ page import="com.ionglobal.misc.*" %>
<%@ page import="com.ionglobal.lib.*" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="com.gzgi.weqs.partsmanage.PartsManageApp" %>
<%@ page import="com.gzgi.weqs.partsmanage.PartsManage" %>
<%@ include file="/include/init_include.jsp" %>
<%
	StringBuffer stringBuffer = new StringBuffer();

	String sql = "Select distinct(scarType) from pqm_partsManage";
	ResultSet rs = dbi.execQuery(sql);
	if(rs!=null){
		stringBuffer.append("[");
		while(dbi.rsNext()){
			stringBuffer.append("{");
			stringBuffer.append("\"id\":\""+dbi.rsGetString("scarType")+"\",");
			stringBuffer.append("\"text\":\""+dbi.rsGetString("scarType")+"\"");
			stringBuffer.append("},");
		}
		stringBuffer.deleteCharAt(stringBuffer.length()-1);
		stringBuffer.append("]");
	}
	dbi.rsClose();
	
	String info=stringBuffer.toString();
	System.out.println(info);
	out.println(info);
%>
<%@ include file="/include/init_free.jsp" %>
